import pandas as pd
from pandas import DataFrame

l1 = [
    [" sds ","sd"],
   ["ancd ","  sd  "]
]

print(l1)

df = pd.DataFrame(l1,columns = ['A','B'])
print(df['A'].loc[0])
df['A'] = df['A'].str.strip()
print(df['A'].loc[0])



# file = 'D:\\userDir\\Desktop\\1.xlsx'
#
# df = pd.read_excel(file)
# print(df)
#
# groups = df.groupby('分类')
# print(groups)
#
# g1 = groups.get_group("应收账款")
# g2 = groups.get_group("合同资产")
#
# g1 = pd.DataFrame(g1)
# g2 = pd.DataFrame(g2)
#
# g1=pd.concat([g1,g2])
#
# print(g1)
# print(g2)
# print()
# print(g2)

# d1 = {}
# d1["a"]=123
#
# b = 'a' in d1
#
#
# print(b)
# print(d1['a'])
#
# # char to ascii ord
# for i in range(10):
#     print(chr(ord('A')+i))
